package com.sto.stoapp.db.constant;

/**
 * 登陆信息接口
 * 
 * @author mgf
 * 
 */
public interface StoLoginInfoConstant {
	/**
	 * 工号
	 */
	public static final String JOB_NUMBER = "job_number";

	/**
	 * 密码
	 */
	public static final String PASSWORD_INFO = "password_info";

	/**
	 * 登陆属性位
	 */
	public static final String LOGIN_ATTRIBUTE = "login_attribute";

	/**
	 * 登陆网点名称
	 */
	public static final String LOGIN_SITE_NAME = "login_site_name";

	/**
	 * 登陆名称
	 */
	public static final String LOGIN_NAME = "login_name";

	/**
	 * 手机号码
	 */
	public static final String TELPHONE_NUMBER = "telphone_number";

	/**
	 * 登陆信息数据库表
	 */
	public static final String LOGIN_INFO_TABLE = "login_info_table";
	
	/**
     * 组织类型
     */
    public static final String ORG_TYPE = "org_type";
    /**
     * 航空标识
     */
    public static final String ORG_AIR_TYPE = "org_air_type";

	/**
	 * 创建登陆信息数据库表
	 */
	public static final String CREATE_LOGIN_INFO_TABLE = "CREATE TABLE "
			+ " if not exists " + LOGIN_INFO_TABLE + "(" + JOB_NUMBER
			+ " char(6)  primary key" + "," + PASSWORD_INFO + " char(6)" + ","
			+ LOGIN_ATTRIBUTE + " char(2)" + "," + LOGIN_SITE_NAME
			+ " char(20)" + "," + LOGIN_NAME + " char(10)" + ","
			+ ORG_TYPE + " char(12), "
			+ ORG_AIR_TYPE + " char(12), "
			+ TELPHONE_NUMBER + " char(20)" + ")";

	/**
	 * 删除登陆信息数据库表
	 */
	public static final String DROP_LOGIN_INFO_TABLE = "drop table if exists "
			+ LOGIN_INFO_TABLE;
}
